---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table7.log
  log type:  text
 opened on:  11 Jun 2020, 10:17:11

. 
. **** Legislative analysis
. 
. use "$path/foreclosures_leg_analysis.dta", clear

. 
. ***** Table on legislative effects
. 
. foreach j in sen cong {
  2. 
.         bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe `j'_vs foreclosure_rate foreclosure_inc [aw=pop_y], a(fips sy) cluster(fips)
  3.         local `j'b1 = _b[foreclosure_rate]
  4.         local `j'se1 = _se[foreclosure_rate]
  5.         local `j'bint1 = _b[foreclosure_inc]
  6.         local `j'seint1 = _se[foreclosure_inc]
  7.         local `j'n1 = e(N)
  8.         local `j'nclust1 = e(N_clust)
  9.         
.         bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe `j'_vs foreclosure_rate foreclosure_inc [aw=pop_y], a(fips popyear) cluster(fips)
 10.         local `j'b2 = _b[foreclosure_rate]
 11.         local `j'se2 = _se[foreclosure_rate]
 12.         local `j'bint2 = _b[foreclosure_inc]
 13.         local `j'seint2 = _se[foreclosure_inc]
 14.         local `j'n2 = e(N)
 15.         local `j'nclust2 = e(N_clust)
 16.         
.         bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe `j'_vs foreclosure_rate foreclosure_inc [aw=pop_y], a(i.fips##c.year sy) cluster(fips)
 17.         local `j'b3 = _b[foreclosure_rate]
 18.         local `j'se3 = _se[foreclosure_rate]
 19.         local `j'bint3 = _b[foreclosure_inc]
 20.         local `j'seint3 = _se[foreclosure_inc]
 21.         local `j'n3 = e(N)
 22.         local `j'nclust3 = e(N_clust)
 23.         
.         bootstrap _b, rep(1e3) seed(94305) cluster(fips) force: reghdfe `j'_vs foreclosure_rate foreclosure_inc [aw=pop_y], a(i.fips##c.year popyear) cluster(fips)
 24.         local `j'b4 = _b[foreclosure_rate]
 25.         local `j'se4 = _se[foreclosure_rate]
 26.         local `j'bint4 = _b[foreclosure_inc]
 27.         local `j'seint4 = _se[foreclosure_inc]
 28.         local `j'n4 = e(N)
 29.         local `j'nclust4 = e(N_clust)
 30. 
. }
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     12,171
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =      17.99
                                                Prob > chi2       =     0.0001
                                                R-squared         =     0.9708
                                                Adj R-squared     =     0.9614
                                                Root MSE          =     3.8861

                                    (Replications based on 2,718 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
          sen_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -.5497614   .1315082    -4.18   0.000    -.8075128     -.29201
 foreclosure_inc |   .1012454   .0874431     1.16   0.247      -.07014    .2726308
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2718           2718 *   | 
              sy |          264             265              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     12,171
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       8.33
                                                Prob > chi2       =     0.0155
                                                R-squared         =     0.7422
                                                Adj R-squared     =     0.6652
                                                Root MSE          =    11.4422

                                    (Replications based on 2,718 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
          sen_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -.8495653   .3163793    -2.69   0.007    -1.469657   -.2294733
 foreclosure_inc |  -.2025446   .2347529    -0.86   0.388    -.6626519    .2575627
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2718           2718 *   | 
         popyear |           79              80              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     12,171
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       7.33
                                                Prob > chi2       =     0.0257
                                                R-squared         =     0.9861
                                                Adj R-squared     =     0.9738
                                                Root MSE          =     3.2028

                                    (Replications based on 2,718 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
          sen_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -.2682937   .1346676    -1.99   0.046    -.5322374     -.00435
 foreclosure_inc |  -.2652645    .103607    -2.56   0.010    -.4683305   -.0621985
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2718           2718 *   | 
     fips#c.year |         2718            2718              0 ?   | 
              sy |          264             265              1     | 
-------------------------------------------------------------------+
? = number of redundant parameters may be higher
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     12,171
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =      11.48
                                                Prob > chi2       =     0.0032
                                                R-squared         =     0.8427
                                                Adj R-squared     =     0.7123
                                                Root MSE          =    10.6064

                                    (Replications based on 2,718 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
          sen_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -1.306356   .3930959    -3.32   0.001    -2.076809   -.5359017
 foreclosure_inc |   .3679722   .2905191     1.27   0.205    -.2014348    .9373792
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2718           2718 *   | 
     fips#c.year |         2718            2718              0 ?   | 
         popyear |           79              80              1     | 
-------------------------------------------------------------------+
? = number of redundant parameters may be higher
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     18,165
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       7.82
                                                Prob > chi2       =     0.0201
                                                R-squared         =     0.8495
                                                Adj R-squared     =     0.8172
                                                Root MSE          =     9.0579

                                    (Replications based on 2,817 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         cong_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -.4789561   .1788715    -2.68   0.007    -.8295378   -.1283744
 foreclosure_inc |    .281069   .1326928     2.12   0.034     .0209958    .5411422
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2817           2817 *   | 
              sy |          391             392              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     18,165
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       0.81
                                                Prob > chi2       =     0.6665
                                                R-squared         =     0.8189
                                                Adj R-squared     =     0.7846
                                                Root MSE          =     9.8342

                                    (Replications based on 2,817 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         cong_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |   .1282895   .1443459     0.89   0.374    -.1546233    .4112023
 foreclosure_inc |   -.039114   .1008165    -0.39   0.698    -.2367108    .1584828
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2817           2817 *   | 
         popyear |           79              80              1     | 
-------------------------------------------------------------------+
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     18,165
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       5.08
                                                Prob > chi2       =     0.0790
                                                R-squared         =     0.9038
                                                Adj R-squared     =     0.8560
                                                Root MSE          =     8.0398

                                    (Replications based on 2,817 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         cong_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |  -.0614115   .1635693    -0.38   0.707    -.3820015    .2591785
 foreclosure_inc |   .2401162    .124013     1.94   0.053    -.0029448    .4831772
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2817           2817 *   | 
     fips#c.year |         2817            2817              0 ?   | 
              sy |          391             392              1     | 
-------------------------------------------------------------------+
? = number of redundant parameters may be higher
* = fixed effect nested within cluster; treated as redundant for DoF computation
(running reghdfe on estimation sample)

Bootstrap replications (1000)
----+--- 1 ---+--- 2 ---+--- 3 ---+--- 4 ---+--- 5 
..................................................    50
..................................................   100
..................................................   150
..................................................   200
..................................................   250
..................................................   300
..................................................   350
..................................................   400
..................................................   450
..................................................   500
..................................................   550
..................................................   600
..................................................   650
..................................................   700
..................................................   750
..................................................   800
..................................................   850
..................................................   900
..................................................   950
..................................................  1000

HDFE Linear regression                          Number of obs     =     18,165
Absorbing 2 HDFE groups                         Replications      =      1,000
                                                Wald chi2(2)      =       5.21
                                                Prob > chi2       =     0.0737
                                                R-squared         =     0.8872
                                                Adj R-squared     =     0.8354
                                                Root MSE          =     8.5957

                                    (Replications based on 2,817 clusters in fips)
----------------------------------------------------------------------------------
                 |   Observed   Bootstrap                         Normal-based
         cong_vs |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
foreclosure_rate |   .0813856    .135029     0.60   0.547    -.1832663    .3460374
 foreclosure_inc |   .1573323    .088474     1.78   0.075    -.0160734    .3307381
----------------------------------------------------------------------------------

Absorbed degrees of freedom:
-------------------------------------------------------------------+
     Absorbed FE |  Num. Coefs.  =   Categories  -   Redundant     | 
-----------------+-------------------------------------------------|
            fips |            0            2817           2817 *   | 
     fips#c.year |         2817            2817              0 ?   | 
         popyear |           79              80              1     | 
-------------------------------------------------------------------+
? = number of redundant parameters may be higher
* = fixed effect nested within cluster; treated as redundant for DoF computation

. 
. log close
      name:  <unnamed>
       log:  /Users/jesse/Dropbox/Ohio-HallResearch/Code/replication/table7.log
  log type:  text
 closed on:  11 Jun 2020, 11:03:56
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
